Attribute | Description (where applicable) |
Contractor | Contractor Y/N, represented by 1/0 |
Employee Category | Employee Category built as Company + '-' + Code + '-' + Name |
Employee Category Code | Employee Category Code |
Employee Category Code Name | Built as Company + '-' + Code + '-' + Name |
Employee Category Name | Employee Category Name |
Remark | Remark |
Company ID | Company Code |
Hierarchy | Level |
EmployeeCategoryHy | |
Company ID | |
Employee Category Code |
Model Name |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
EMPLOYEE CATEGORY | DIM_EMPLOYEE_CATEGORY_TM | DIM_EMPLOYEE_CATEGORY_BI | DIM_EMPLOYEE_CATEGORY | On Line |